Calc Type on Sub Total or Footer rows. This option is available on the Sub Total or Footer rows. The user can select the calculation type from a drop-down list. This will then use the values from the same column in the above rows for the calculation.

The fields that are returned from the view will be displayed in a drop-down list. Select the field name you want to display in your cell.

Maximum 50 characters

Can be left blank to use start date, otherwise should be in the following format:

[yy] or [MM] (this is case sensitive), + or -, then an integer

e.g., ' [MM]+1 ' for month plus 1, or ' [yy]-3 ' for 3 years ago

• 0.00 – Will display the value to 2 decimal places
• 0.000 – Will display the value to 3 decimal places
• 0,000 – For values in the thousands and to display a comma
• dd/MM/yyyy – Format date with slashes. 2010-12-30 becomes 30/12/2010.
• dd MMM yy – 2010-12-30 is rendered as 30 Dec 10. Note: Date values in properties are expected to be stored in yyyy-MM-dd format by default.
• $#,###,##0.00 – Format number with two decimals and dollar symbol. 1234.5 is formatted as $1,234.50.
• Maximum 50 characters

“Link Type” defaults to Custom.

With a Custom link, the “Link/URL” field is displayed.

On entering text into the “Link/URL” field, the “Link/URL Parameters” and “Link/URL Target” fields appear.

Selecting Engineering Chart from the “Link Type” field, does not require “Link/URL” or “Link/URL Parameters” to be completed, so they are not displayed. Only the “Link/URL Target” field appears.

The page to be displayed. No parameters should be entered here.

The link for charts is the same across the whole system. To drill down to a chart set:

• Link/URL = multipleCharts.jsp
• Link/URL Parameters = ignore=me&caller=3&thePointIdents=[$pointid]

To link to another dashboard:

At times, it may be necessary to link from a table to another dashboard, perhaps at a site level further down. If this is the case, please follow the instructions below.

It is now possible to use the following JavaScript function call within this cell:

• javascript:top.redirectToDashboard(<dashID>,<siteID>,<period – single quotes around>,<year>,<month>,<propertyname>,<propertyvalue>)

OR

• Shortened version without all optional parameters: javascript:top.redirectToDashboard(<dashID>,<siteID>)

Examples of how this could be used are shown below:

• Fixed table
  • In fixed tables there would be no string replacements, and so each dashID/siteID etc would be manually entered…
  • javascript:top.redirectToDashboard(21, 9932)
• Iterative Table
  • Iterative table introduces the concept similar to that of the Link/URL Parameters below in that it handles the replacement of certain string values ([$containerid], [$value], [$datetime], [$pointid], [$pointid:pointname], [$view:colname], [$]). These values are explained further in the section below “Link/URL Parameters”.
  • javascript:top.redirectToDashboard(21, [$containerid])

The above statement would be the most common use of this feature. This would take a user to dashboard 21, and pass in the site id (container id) of the selected row in the table.

In some cases, this dashboard may not be enabled for the site passed in. If so the system will handle this and redirect the user to the first dashboard available at the site level passed through.

In order to use this new function/feature of the custom table the “Link/URL Target” must be set to _self, this is to allow the page to have knowledge of the function further up within the frames.

Maximum 200 characters

• [$containerid] – Will replace this text with the container id passed across to the widget.
• [$value] – Replace this text with the value of the cell (will be url encoded).
• [$datetime] – Replace this text with 14 digits based on the date time. Can be used to prevent caching on a web page.
• [$pointid] – Replace this text with the pointid of this cell. Only applicable to point cells on the detail row. Will be blank on other cell types.
• [$pointid:pointname] – Replace this text with the data from the point named pointname on the detail row. Will be blank if pointname doesn’t exist.
• [$view:colname] – Replace this text with the data from the column named colname on the view. Should only be used when linking the table into a sql view.
• [$] – Use the value passed on the equivalent parameter on the webpage URL. The value of the keyed parameter must be set exactly to [$]. i.e. param1=[$], not param1=X[$]. It is not possible to add characters to the parameter (the X) when using [$] command.
• &PopUp=true - Add &Popup=true to the URL if you are loading a dashboard in a colorbox, to prevent navigation issues.

Maximum 200 characters

• Blank – New browser tab or window.
• Self – The new page should be opening in the current browser frame/tab/window.
• Parent – The new page should be opened in the parent browser frame of tab (if applicable) or the current browser tab/window.

Enter the name of the container to iterate by (free text), and then the Point field will be a drop-down containing only the point names within the "Containers Within" container.

If it has been set to Container, the "Containers Within" field appears.

Enter the name of the container to iterate by (free text), and then the Property field will be a drop-down containing only properties (attributes) from containers within the "Containers Within" container.

• None
• String (Ascending)
• String (Descending)
• Numeric (Ascending)
• Numeric (Descending)
• Date (Ascending)
• Date (Descending)

Once the table is populated with data, the column can be sorted by clicking on it. An arrow will appear to show how the data has been ordered. In this example, the data has been ordered alphabetically ascending.